Pandas Profile Report

Dataset statistics

Number of variables	18
Number of observations	12330
Missing cells	700
Missing cells (%)	0.3%
Duplicate rows	59
Duplicate rows (%)	0.5%
Total size in memory	4.0 MiB
Average record size in memory	342.9 B

Variable types

Numeric	14
Categorical	3
Boolean	1

Alerts

Dataset has 59 (0.5%) duplicate rows	Duplicates
`Administrative` is highly overall correlated with `Administrative_Duration`	High correlation
`Administrative_Duration` is highly overall correlated with `Administrative`	High correlation
`BounceRates` is highly overall correlated with `ExitRates`	High correlation
`ExitRates` is highly overall correlated with `BounceRates` and 1 other fields	High correlation
`Informational` is highly overall correlated with `Informational_Duration`	High correlation
`Informational_Duration` is highly overall correlated with `Informational`	High correlation
`ProductRelated` is highly overall correlated with `ExitRates` and 1 other fields	High correlation
`ProductRelated_Duration` is highly overall correlated with `ProductRelated`	High correlation
`VisitorType` is highly imbalanced (59.9%)	Imbalance
`Browser` has 184 (1.5%) missing values	Missing
`Region` has 246 (2.0%) missing values	Missing
`Revenue` has 147 (1.2%) missing values	Missing
`Administrative_Duration` is highly skewed (γ1 = 28.62347698)	Skewed
`Administrative` has 5704 (46.3%) zeros	Zeros
`Administrative_Duration` has 5898 (47.8%) zeros	Zeros
`Informational` has 9699 (78.7%) zeros	Zeros
`Informational_Duration` has 9925 (80.5%) zeros	Zeros
`ProductRelated_Duration` has 755 (6.1%) zeros	Zeros
`BounceRates` has 5241 (42.5%) zeros	Zeros
`PageValues` has 9600 (77.9%) zeros	Zeros
`SpecialDay` has 10971 (89.0%) zeros	Zeros

Reproduction

Analysis started	2025-04-11 09:15:17.526212
Analysis finished	2025-04-11 09:15:27.516792
Duration	9.99 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

Administrative
Real number (ℝ)

High correlation Zeros

Distinct	37
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.2381995

Minimum	-10
Maximum	27
Zeros	5704
Zeros (%)	46.3%
Negative	123
Negative (%)	1.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	-10
5-th percentile	0
Q1	0
median	1
Q3	4
95-th percentile	9
Maximum	27
Range	37
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.4092693
Coefficient of variation (CV)	1.5232196
Kurtosis	4.5240775
Mean	2.2381995
Median Absolute Deviation (MAD)	1
Skewness	1.6941611
Sum	27597
Variance	11.623117
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
0	5704	46.3%
1	1341	10.9%
2	1101	8.9%
3	909	7.4%
4	757	6.1%
5	574	4.7%
6	428	3.5%
7	334	2.7%
8	285	2.3%
9	223	1.8%
Other values (27)	674	5.5%

Value	Count	Frequency (%)
-10	6	< 0.1%
-9	15	0.1%
-8	17	0.1%
-7	14	0.1%
-6	16	0.1%
-5	16	0.1%
-4	6	< 0.1%
-3	13	0.1%
-2	6	< 0.1%
-1	14	0.1%

Value	Count	Frequency (%)
27	1	< 0.1%
26	1	< 0.1%
24	4	< 0.1%
23	3	< 0.1%
22	4	< 0.1%
21	2	< 0.1%
20	2	< 0.1%
19	6	< 0.1%
18	11	0.1%
17	16	0.1%

Administrative_Duration
Real number (ℝ)

High correlation Skewed Zeros

Distinct	3345
Distinct (%)	27.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1269.776

Minimum	0
Maximum	989493
Zeros	5898
Zeros (%)	47.8%
Negative	0
Negative (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	8
Q3	93.7875
95-th percentile	353.27625
Maximum	989493
Range	989493
Interquartile range (IQR)	93.7875

Descriptive statistics

Standard deviation	34071.467
Coefficient of variation (CV)	26.832659
Kurtosis	817.5146
Mean	1269.776
Median Absolute Deviation (MAD)	8
Skewness	28.623477
Sum	15656338
Variance	1.1608649 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5898	47.8%
4	56	0.5%
5	53	0.4%
7	45	0.4%
11	42	0.3%
6	41	0.3%
14	36	0.3%
9	35	0.3%
15	33	0.3%
10	32	0.3%
Other values (3335)	6059	49.1%

Value	Count	Frequency (%)
0	5898	47.8%
1.333333333	1	< 0.1%
2	15	0.1%
3	26	0.2%
3.5	4	< 0.1%
4	56	0.5%
4.333333333	1	< 0.1%
4.5	2	< 0.1%
4.75	1	< 0.1%
5	53	0.4%

Value	Count	Frequency (%)
989493	1	< 0.1%
987522	1	< 0.1%
985308	1	< 0.1%
985147	1	< 0.1%
984643	1	< 0.1%
984508	1	< 0.1%
980612	1	< 0.1%
977747	1	< 0.1%
973917	1	< 0.1%
971707	1	< 0.1%

Informational
Real number (ℝ)

High correlation Zeros

Distinct	17
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.50356853

Minimum	0
Maximum	24
Zeros	9699
Zeros (%)	78.7%
Negative	0
Negative (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3
Maximum	24
Range	24
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.2701564
Coefficient of variation (CV)	2.522311
Kurtosis	26.932266
Mean	0.50356853
Median Absolute Deviation (MAD)	0
Skewness	4.0364638
Sum	6209
Variance	1.6132973
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	9699	78.7%
1	1041	8.4%
2	728	5.9%
3	380	3.1%
4	222	1.8%
5	99	0.8%
6	78	0.6%
7	36	0.3%
9	15	0.1%
8	14	0.1%
Other values (7)	18	0.1%

Value	Count	Frequency (%)
0	9699	78.7%
1	1041	8.4%
2	728	5.9%
3	380	3.1%
4	222	1.8%
5	99	0.8%
6	78	0.6%
7	36	0.3%
8	14	0.1%
9	15	0.1%

Value	Count	Frequency (%)
24	1	< 0.1%
16	1	< 0.1%
14	2	< 0.1%
13	1	< 0.1%
12	5	< 0.1%
11	1	< 0.1%
10	7	0.1%
9	15	0.1%
8	14	0.1%
7	36	0.3%

Informational_Duration
Real number (ℝ)

High correlation Zeros

Distinct	1258
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.472398

Minimum	0
Maximum	2549.375
Zeros	9925
Zeros (%)	80.5%
Negative	0
Negative (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	195
Maximum	2549.375
Range	2549.375
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	140.74929
Coefficient of variation (CV)	4.0829563
Kurtosis	76.316853
Mean	34.472398
Median Absolute Deviation (MAD)	0
Skewness	7.5791847
Sum	425044.67
Variance	19810.364
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9925	80.5%
9	33	0.3%
7	26	0.2%
10	26	0.2%
6	26	0.2%
12	23	0.2%
13	23	0.2%
16	22	0.2%
8	22	0.2%
11	21	0.2%
Other values (1248)	2183	17.7%

Value	Count	Frequency (%)
0	9925	80.5%
1	3	< 0.1%
1.5	1	< 0.1%
2	11	0.1%
2.5	1	< 0.1%
3	16	0.1%
3.5	1	< 0.1%
4	17	0.1%
5	18	0.1%
5.5	3	< 0.1%

Value	Count	Frequency (%)
2549.375	1	< 0.1%
2256.916667	1	< 0.1%
2252.033333	1	< 0.1%
2195.3	1	< 0.1%
2166.5	1	< 0.1%
2050.433333	1	< 0.1%
1949.166667	1	< 0.1%
1830.5	1	< 0.1%
1779.166667	1	< 0.1%
1778	1	< 0.1%

ProductRelated
Real number (ℝ)

High correlation

Distinct	311
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.731468

Minimum	0
Maximum	705
Zeros	38
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	7
median	18
Q3	38
95-th percentile	109
Maximum	705
Range	705
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	44.475503
Coefficient of variation (CV)	1.4016214
Kurtosis	31.211707
Mean	31.731468
Median Absolute Deviation (MAD)	13
Skewness	4.3415164
Sum	391249
Variance	1978.0704
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	622	5.0%
2	465	3.8%
3	458	3.7%
4	404	3.3%
6	396	3.2%
7	391	3.2%
5	382	3.1%
8	370	3.0%
10	330	2.7%
9	317	2.6%
Other values (301)	8195	66.5%

Value	Count	Frequency (%)
0	38	0.3%
1	622	5.0%
2	465	3.8%
3	458	3.7%
4	404	3.3%
5	382	3.1%
6	396	3.2%
7	391	3.2%
8	370	3.0%
9	317	2.6%

Value	Count	Frequency (%)
705	1	< 0.1%
686	1	< 0.1%
584	1	< 0.1%
534	1	< 0.1%
518	1	< 0.1%
517	1	< 0.1%
501	1	< 0.1%
486	1	< 0.1%
470	1	< 0.1%
449	1	< 0.1%

ProductRelated_Duration
Real number (ℝ)

High correlation Zeros

Distinct	9551
Distinct (%)	77.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1194.7462

Minimum	0
Maximum	63973.522
Zeros	755
Zeros (%)	6.1%
Negative	0
Negative (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	184.1375
median	598.9369
Q3	1464.1572
95-th percentile	4300.2891
Maximum	63973.522
Range	63973.522
Interquartile range (IQR)	1280.0197

Descriptive statistics

Standard deviation	1913.6693
Coefficient of variation (CV)	1.6017371
Kurtosis	137.17416
Mean	1194.7462
Median Absolute Deviation (MAD)	500.9369
Skewness	7.2632277
Sum	14731221
Variance	3662130.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	755	6.1%
17	21	0.2%
11	17	0.1%
8	17	0.1%
15	16	0.1%
12	15	0.1%
19	15	0.1%
22	15	0.1%
13	14	0.1%
7	14	0.1%
Other values (9541)	11431	92.7%

Value	Count	Frequency (%)
0	755	6.1%
0.5	1	< 0.1%
1	2	< 0.1%
2.333333333	1	< 0.1%
2.666666667	1	< 0.1%
3	5	< 0.1%
4	10	0.1%
5	13	0.1%
5.333333333	1	< 0.1%
6	5	< 0.1%

Value	Count	Frequency (%)
63973.52223	1	< 0.1%
43171.23338	1	< 0.1%
29970.46597	1	< 0.1%
27009.85943	1	< 0.1%
24844.1562	1	< 0.1%
23888.81	1	< 0.1%
23342.08205	1	< 0.1%
23050.10414	1	< 0.1%
21857.04648	1	< 0.1%
21672.24425	1	< 0.1%

BounceRates
Real number (ℝ)

High correlation Zeros

Distinct	2408
Distinct (%)	19.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.044239196

Minimum	-0.49867988
Maximum	2.0989518
Zeros	5241
Zeros (%)	42.5%
Negative	363
Negative (%)	2.9%
Memory size	96.5 KiB

Quantile statistics

Minimum	-0.49867988
5-th percentile	0
Q1	0
median	0.0028955565
Q3	0.018029095
95-th percentile	0.2
Maximum	2.0989518
Range	2.5976317
Interquartile range (IQR)	0.018029095

Descriptive statistics

Standard deviation	0.23973485
Coefficient of variation (CV)	5.4190599
Kurtosis	40.773001
Mean	0.044239196
Median Absolute Deviation (MAD)	0.0028955565
Skewness	6.0191017
Sum	545.46929
Variance	0.0574728
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5241	42.5%
0.2	653	5.3%
0.066666667	126	1.0%
0.028571429	113	0.9%
0.05	109	0.9%
0.033333333	99	0.8%
0.025	98	0.8%
0.016666667	95	0.8%
0.04	94	0.8%
0.1	92	0.7%
Other values (2398)	5610	45.5%

Value	Count	Frequency (%)
-0.4986798793	1	< 0.1%
-0.4983312412	1	< 0.1%
-0.4978888815	1	< 0.1%
-0.4970673082	1	< 0.1%
-0.4952831691	1	< 0.1%
-0.4943992066	1	< 0.1%
-0.4941998756	1	< 0.1%
-0.4929793163	1	< 0.1%
-0.4927393889	1	< 0.1%
-0.4920970926	1	< 0.1%

Value	Count	Frequency (%)
2.098951828	1	< 0.1%
2.088658098	1	< 0.1%
2.086473382	1	< 0.1%
2.083101267	1	< 0.1%
2.075386901	1	< 0.1%
2.07369663	1	< 0.1%
2.071993849	1	< 0.1%
2.068164836	1	< 0.1%
2.067674648	1	< 0.1%
2.066496026	1	< 0.1%

ExitRates
Real number (ℝ)

High correlation

Distinct	4777
Distinct (%)	38.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.043072798

Minimum	0
Maximum	0.2
Zeros	76
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0.004567568
Q1	0.014285714
median	0.025156403
Q3	0.05
95-th percentile	0.2
Maximum	0.2
Range	0.2
Interquartile range (IQR)	0.035714286

Descriptive statistics

Standard deviation	0.048596541
Coefficient of variation (CV)	1.128242
Kurtosis	4.0170346
Mean	0.043072798
Median Absolute Deviation (MAD)	0.01417258
Skewness	2.148789
Sum	531.0876
Variance	0.0023616238
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.2	710	5.8%
0.1	338	2.7%
0.05	329	2.7%
0.033333333	291	2.4%
0.066666667	267	2.2%
0.025	224	1.8%
0.04	214	1.7%
0.016666667	181	1.5%
0.02	167	1.4%
0.022222222	152	1.2%
Other values (4767)	9457	76.7%

Value	Count	Frequency (%)
0	76	0.6%
0.000175593	1	< 0.1%
0.000250438	1	< 0.1%
0.000262123	1	< 0.1%
0.000263158	1	< 0.1%
0.000292398	1	< 0.1%
0.000409836	1	< 0.1%
0.000446429	1	< 0.1%
0.000468384	1	< 0.1%
0.000480769	1	< 0.1%

Value	Count	Frequency (%)
0.2	710	5.8%
0.192307692	1	< 0.1%
0.188888889	2	< 0.1%
0.186666667	4	< 0.1%
0.183333333	2	< 0.1%
0.181818182	1	< 0.1%
0.18034188	1	< 0.1%
0.18	3	< 0.1%
0.177777778	5	< 0.1%
0.175	6	< 0.1%

PageValues
Real number (ℝ)

Zeros

Distinct	2704
Distinct (%)	21.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.8892579

Minimum	0
Maximum	361.76374
Zeros	9600
Zeros (%)	77.9%
Negative	0
Negative (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	38.160528
Maximum	361.76374
Range	361.76374
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	18.568437
Coefficient of variation (CV)	3.1529332
Kurtosis	65.635694
Mean	5.8892579
Median Absolute Deviation (MAD)	0
Skewness	6.3829642
Sum	72614.549
Variance	344.78684
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9600	77.9%
53.988	6	< 0.1%
42.29306752	3	< 0.1%
59.988	2	< 0.1%
16.1585582	2	< 0.1%
44.89345937	2	< 0.1%
14.1273698	2	< 0.1%
34.03997536	2	< 0.1%
10.99901844	2	< 0.1%
58.9241766	2	< 0.1%
Other values (2694)	2707	22.0%

Value	Count	Frequency (%)
0	9600	77.9%
0.038034542	1	< 0.1%
0.067049546	1	< 0.1%
0.093546949	1	< 0.1%
0.098621403	1	< 0.1%
0.120699914	1	< 0.1%
0.129676893	1	< 0.1%
0.131837013	1	< 0.1%
0.139200623	1	< 0.1%
0.150650498	1	< 0.1%

Value	Count	Frequency (%)
361.7637419	1	< 0.1%
360.9533839	1	< 0.1%
287.9537928	1	< 0.1%
270.7846931	1	< 0.1%
261.4912857	1	< 0.1%
258.5498732	1	< 0.1%
255.5691579	1	< 0.1%
254.6071579	1	< 0.1%
246.7585902	1	< 0.1%
239.98	1	< 0.1%

SpecialDay
Real number (ℝ)

Zeros

Distinct	6
Distinct (%)	< 0.1%
Missing	123
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.061259933

Minimum	0
Maximum	1
Zeros	10971
Zeros (%)	89.0%
Negative	0
Negative (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.6
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.19864976
Coefficient of variation (CV)	3.2427355
Kurtosis	9.9567589
Mean	0.061259933
Median Absolute Deviation (MAD)	0
Skewness	3.3087006
Sum	747.8
Variance	0.039461726
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	10971	89.0%
0.6	346	2.8%
0.8	321	2.6%
0.4	240	1.9%
0.2	177	1.4%
1	152	1.2%
(Missing)	123	1.0%

Value	Count	Frequency (%)
0	10971	89.0%
0.2	177	1.4%
0.4	240	1.9%
0.6	346	2.8%
0.8	321	2.6%
1	152	1.2%

Value	Count	Frequency (%)
1	152	1.2%
0.8	321	2.6%
0.6	346	2.8%
0.4	240	1.9%
0.2	177	1.4%
0	10971	89.0%

Month
Categorical

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	723.1 KiB

May	3196
Nov	2998
Mar	1907
Dec	1727
Oct	549
Other values (7)	1953

Length

Max length	4
Median length	3
Mean length	3.0442011
Min length	3

Characters and Unicode

Total characters	37535
Distinct characters	23
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Feb
2nd row	Feb
3rd row	Feb
4th row	Feb
5th row	Feb

Common Values

Value	Count	Frequency (%)
May	3196	25.9%
Nov	2998	24.3%
Mar	1907	15.5%
Dec	1727	14.0%
Oct	549	4.5%
Aug	433	3.5%
Jul	432	3.5%
Sep	359	2.9%
June	288	2.3%
Feb	184	1.5%
Other values (2)	257	2.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
may	3196	25.9%
nov	2998	24.3%
mar	1907	15.5%
dec	1727	14.0%
oct	549	4.5%
aug	433	3.5%
jul	432	3.5%
sep	359	2.9%
june	288	2.3%
feb	184	1.5%
Other values (2)	257	2.1%

Most occurring characters

Value	Count	Frequency (%)
M	5103	13.6%
a	5103	13.6%
y	3196	8.5%
N	2998	8.0%
o	2998	8.0%
v	2998	8.0%
e	2647	7.1%
c	2444	6.5%
r	2075	5.5%
D	1727	4.6%
Other values (13)	6246	16.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	25205	67.2%
Uppercase Letter	12330	32.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	5103	20.2%
y	3196	12.7%
o	2998	11.9%
v	2998	11.9%
e	2647	10.5%
c	2444	9.7%
r	2075	8.2%
u	1321	5.2%
t	638	2.5%
p	448	1.8%
Other values (4)	1337	5.3%

Uppercase Letter

Value	Count	Frequency (%)
M	5103	41.4%
N	2998	24.3%
D	1727	14.0%
J	720	5.8%
O	549	4.5%
S	448	3.6%
A	433	3.5%
F	184	1.5%
T	168	1.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	37535	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
M	5103	13.6%
a	5103	13.6%
y	3196	8.5%
N	2998	8.0%
o	2998	8.0%
v	2998	8.0%
e	2647	7.1%
c	2444	6.5%
r	2075	5.5%
D	1727	4.6%
Other values (13)	6246	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37535	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
M	5103	13.6%
a	5103	13.6%
y	3196	8.5%
N	2998	8.0%
o	2998	8.0%
v	2998	8.0%
e	2647	7.1%
c	2444	6.5%
r	2075	5.5%
D	1727	4.6%
Other values (13)	6246	16.6%

OperatingSystems
Real number (ℝ)

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1240065

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	3
95-th percentile	3
Maximum	8
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.91132483
Coefficient of variation (CV)	0.42905934
Kurtosis	10.456843
Mean	2.1240065
Median Absolute Deviation (MAD)	0
Skewness	2.066285
Sum	26189
Variance	0.83051294
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	6601	53.5%
1	2585	21.0%
3	2555	20.7%
4	478	3.9%
8	79	0.6%
6	19	0.2%
7	7	0.1%
5	6	< 0.1%

Value	Count	Frequency (%)
1	2585	21.0%
2	6601	53.5%
3	2555	20.7%
4	478	3.9%
5	6	< 0.1%
6	19	0.2%
7	7	0.1%
8	79	0.6%

Value	Count	Frequency (%)
8	79	0.6%
7	7	0.1%
6	19	0.2%
5	6	< 0.1%
4	478	3.9%
3	2555	20.7%
2	6601	53.5%
1	2585	21.0%

Browser
Real number (ℝ)

Missing

Distinct	13
Distinct (%)	0.1%
Missing	184
Missing (%)	1.5%
Infinite	0
Infinite (%)	0.0%
Mean	2.3602832

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	5
Maximum	13
Range	12
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.7220006
Coefficient of variation (CV)	0.72957373
Kurtosis	12.682995
Mean	2.3602832
Median Absolute Deviation (MAD)	0
Skewness	3.2352112
Sum	28668
Variance	2.9652862
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
2	7835	63.5%
1	2424	19.7%
4	725	5.9%
5	465	3.8%
6	171	1.4%
10	160	1.3%
8	135	1.1%
3	104	0.8%
13	61	0.5%
7	49	0.4%
Other values (3)	17	0.1%
(Missing)	184	1.5%

Value	Count	Frequency (%)
1	2424	19.7%
2	7835	63.5%
3	104	0.8%
4	725	5.9%
5	465	3.8%
6	171	1.4%
7	49	0.4%
8	135	1.1%
9	1	< 0.1%
10	160	1.3%

Value	Count	Frequency (%)
13	61	0.5%
12	10	0.1%
11	6	< 0.1%
10	160	1.3%
9	1	< 0.1%
8	135	1.1%
7	49	0.4%
6	171	1.4%
5	465	3.8%
4	725	5.9%

Region
Real number (ℝ)

Missing

Distinct	9
Distinct (%)	0.1%
Missing	246
Missing (%)	2.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.1456471

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	4
95-th percentile	8
Maximum	9
Range	8
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.4024399
Coefficient of variation (CV)	0.7637347
Kurtosis	-0.14821254
Mean	3.1456471
Median Absolute Deviation (MAD)	2
Skewness	0.98434139
Sum	38012
Variance	5.7717174
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
1	4695	38.1%
3	2345	19.0%
4	1157	9.4%
2	1113	9.0%
6	787	6.4%
7	743	6.0%
9	501	4.1%
8	427	3.5%
5	316	2.6%
(Missing)	246	2.0%

Value	Count	Frequency (%)
1	4695	38.1%
2	1113	9.0%
3	2345	19.0%
4	1157	9.4%
5	316	2.6%
6	787	6.4%
7	743	6.0%
8	427	3.5%
9	501	4.1%

Value	Count	Frequency (%)
9	501	4.1%
8	427	3.5%
7	743	6.0%
6	787	6.4%
5	316	2.6%
4	1157	9.4%
3	2345	19.0%
2	1113	9.0%
1	4695	38.1%

TrafficType
Real number (ℝ)

Distinct	20
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.0695864

Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	4
95-th percentile	13
Maximum	20
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	4.0251692
Coefficient of variation (CV)	0.98908557
Kurtosis	3.4797106
Mean	4.0695864
Median Absolute Deviation (MAD)	1
Skewness	1.9629867
Sum	50178
Variance	16.201987
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
2	3913	31.7%
1	2451	19.9%
3	2052	16.6%
4	1069	8.7%
13	738	6.0%
10	450	3.6%
6	444	3.6%
8	343	2.8%
5	260	2.1%
11	247	2.0%
Other values (10)	363	2.9%

Value	Count	Frequency (%)
1	2451	19.9%
2	3913	31.7%
3	2052	16.6%
4	1069	8.7%
5	260	2.1%
6	444	3.6%
7	40	0.3%
8	343	2.8%
9	42	0.3%
10	450	3.6%

Value	Count	Frequency (%)
20	198	1.6%
19	17	0.1%
18	10	0.1%
17	1	< 0.1%
16	3	< 0.1%
15	38	0.3%
14	13	0.1%
13	738	6.0%
12	1	< 0.1%
11	247	2.0%

VisitorType
Categorical

Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	880.2 KiB

Returning_Visitor	10551
New_Visitor	1694
Other	85

Length

Max length	17
Median length	17
Mean length	16.092944
Min length	5

Characters and Unicode

Total characters	198426
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Returning_Visitor
2nd row	Returning_Visitor
3rd row	Returning_Visitor
4th row	Returning_Visitor
5th row	Returning_Visitor

Common Values

Value	Count	Frequency (%)
Returning_Visitor	10551	85.6%
New_Visitor	1694	13.7%
Other	85	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
returning_visitor	10551	85.6%
new_visitor	1694	13.7%
other	85	0.7%

Most occurring characters

Value	Count	Frequency (%)
i	35041	17.7%
t	22881	11.5%
r	22881	11.5%
n	21102	10.6%
e	12330	6.2%
_	12245	6.2%
V	12245	6.2%
s	12245	6.2%
o	12245	6.2%
R	10551	5.3%
Other values (6)	24660	12.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	161606	81.4%
Uppercase Letter	24575	12.4%
Connector Punctuation	12245	6.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	35041	21.7%
t	22881	14.2%
r	22881	14.2%
n	21102	13.1%
e	12330	7.6%
s	12245	7.6%
o	12245	7.6%
u	10551	6.5%
g	10551	6.5%
w	1694	1.0%

Uppercase Letter

Value	Count	Frequency (%)
V	12245	49.8%
R	10551	42.9%
N	1694	6.9%
O	85	0.3%

Connector Punctuation

Value	Count	Frequency (%)
_	12245	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	186181	93.8%
Common	12245	6.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	35041	18.8%
t	22881	12.3%
r	22881	12.3%
n	21102	11.3%
e	12330	6.6%
V	12245	6.6%
s	12245	6.6%
o	12245	6.6%
R	10551	5.7%
u	10551	5.7%
Other values (5)	14109	7.6%

Common

Value	Count	Frequency (%)
_	12245	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	198426	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	35041	17.7%
t	22881	11.5%
r	22881	11.5%
n	21102	10.6%
e	12330	6.2%
_	12245	6.2%
V	12245	6.2%
s	12245	6.2%
o	12245	6.2%
R	10551	5.3%
Other values (6)	24660	12.4%

Weekend
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	744.6 KiB

False	9273
True	2868
Name:Zara	189

Length

Max length	9
Median length	5
Mean length	4.8287105
Min length	4

Characters and Unicode

Total characters	59538
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	False
2nd row	False
3rd row	False
4th row	False
5th row	True

Common Values

Value	Count	Frequency (%)
False	9273	75.2%
True	2868	23.3%
Name:Zara	189	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
false	9273	75.2%
true	2868	23.3%
name:zara	189	1.5%

Most occurring characters

Value	Count	Frequency (%)
e	12330	20.7%
a	9840	16.5%
F	9273	15.6%
l	9273	15.6%
s	9273	15.6%
r	3057	5.1%
T	2868	4.8%
u	2868	4.8%
N	189	0.3%
m	189	0.3%
Other values (2)	378	0.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	46830	78.7%
Uppercase Letter	12519	21.0%
Other Punctuation	189	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	12330	26.3%
a	9840	21.0%
l	9273	19.8%
s	9273	19.8%
r	3057	6.5%
u	2868	6.1%
m	189	0.4%

Uppercase Letter

Value	Count	Frequency (%)
F	9273	74.1%
T	2868	22.9%
N	189	1.5%
Z	189	1.5%

Other Punctuation

Value	Count	Frequency (%)
:	189	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	59349	99.7%
Common	189	0.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	12330	20.8%
a	9840	16.6%
F	9273	15.6%
l	9273	15.6%
s	9273	15.6%
r	3057	5.2%
T	2868	4.8%
u	2868	4.8%
N	189	0.3%
m	189	0.3%

Common

Value	Count	Frequency (%)
:	189	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	59538	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	12330	20.7%
a	9840	16.5%
F	9273	15.6%
l	9273	15.6%
s	9273	15.6%
r	3057	5.1%
T	2868	4.8%
u	2868	4.8%
N	189	0.3%
m	189	0.3%
Other values (2)	378	0.6%

Revenue
Boolean

Missing

Distinct	2
Distinct (%)	< 0.1%
Missing	147
Missing (%)	1.2%
Memory size	433.0 KiB

False	10303
True	1880
(Missing)	147

Value	Count	Frequency (%)
False	10303	83.6%
True	1880	15.2%
(Missing)	147	1.2%

	Administrative	Administrative_Duration	BounceRates	Browser	ExitRates	Informational	Informational_Duration	Month	OperatingSystems	PageValues	ProductRelated	ProductRelated_Duration	Region	Revenue	SpecialDay	TrafficType	VisitorType	Weekend
Administrative	1.000	0.920	-0.126	-0.009	-0.425	0.361	0.354	0.059	-0.001	0.324	0.452	0.415	0.011	0.138	-0.125	-0.013	0.102	0.037
Administrative_Duration	0.920	1.000	-0.133	-0.022	-0.437	0.356	0.351	0.021	-0.008	0.316	0.429	0.412	0.018	0.007	-0.131	-0.016	0.035	0.000
BounceRates	-0.126	-0.133	1.000	-0.046	0.533	0.009	0.002	0.050	0.051	-0.104	-0.037	-0.067	-0.011	0.162	0.127	0.019	0.114	0.027
Browser	-0.009	-0.022	-0.046	1.000	-0.017	-0.020	-0.013	0.060	0.375	0.025	0.044	0.045	0.057	0.037	0.018	0.000	0.475	0.039
ExitRates	-0.425	-0.437	0.533	-0.017	1.000	-0.186	-0.200	0.058	0.022	-0.308	-0.519	-0.477	-0.003	0.245	0.152	0.022	0.184	0.044
Informational	0.361	0.356	0.009	-0.020	-0.186	1.000	0.951	0.016	0.000	0.219	0.369	0.368	-0.023	0.078	-0.054	-0.029	0.028	0.014
Informational_Duration	0.354	0.351	0.002	-0.013	-0.200	0.951	1.000	0.000	0.003	0.224	0.361	0.363	-0.015	0.067	-0.054	-0.026	0.008	0.000
Month	0.059	0.021	0.050	0.060	0.058	0.016	0.000	1.000	0.058	0.018	0.068	0.046	0.037	0.175	0.236	0.160	0.137	0.041
OperatingSystems	-0.001	-0.008	0.051	0.375	0.022	0.000	0.003	0.058	1.000	-0.012	0.021	0.023	0.027	0.074	0.022	0.080	0.465	0.086
PageValues	0.324	0.316	-0.104	0.025	-0.308	0.219	0.224	0.018	-0.012	1.000	0.342	0.360	0.002	0.413	-0.070	-0.018	0.110	0.048
ProductRelated	0.452	0.429	-0.037	0.044	-0.519	0.369	0.361	0.068	0.021	0.342	1.000	0.883	-0.020	0.127	-0.022	-0.070	0.079	0.000
ProductRelated_Duration	0.415	0.412	-0.067	0.045	-0.477	0.368	0.363	0.046	0.023	0.360	0.883	1.000	-0.008	0.069	-0.049	-0.073	0.035	0.000
Region	0.011	0.018	-0.011	0.057	-0.003	-0.023	-0.015	0.037	0.027	0.002	-0.020	-0.008	1.000	0.007	-0.016	-0.005	0.186	0.016
Revenue	0.138	0.007	0.162	0.037	0.245	0.078	0.067	0.175	0.074	0.413	0.127	0.069	0.007	1.000	0.086	0.121	0.105	0.031
SpecialDay	-0.125	-0.131	0.127	0.018	0.152	-0.054	-0.054	0.236	0.022	-0.070	-0.022	-0.049	-0.016	0.086	1.000	0.110	0.065	0.183
TrafficType	-0.013	-0.016	0.019	0.000	0.022	-0.029	-0.026	0.160	0.080	-0.018	-0.070	-0.073	-0.005	0.121	0.110	1.000	0.316	0.064
VisitorType	0.102	0.035	0.114	0.475	0.184	0.028	0.008	0.137	0.465	0.110	0.079	0.035	0.186	0.105	0.065	0.316	1.000	0.038
Weekend	0.037	0.000	0.027	0.039	0.044	0.014	0.000	0.041	0.086	0.048	0.000	0.000	0.016	0.031	0.183	0.064	0.038	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	Administrative	ProductRelated	ProductRelated_Duration	BounceRates	ExitRates	SpecialDay	Month	OperatingSystems	Browser	Region	TrafficType	VisitorType	Weekend	Revenue
0	0	1	0.000000	0.200000	0.200000	0.0	Feb	1	NaN	1.0	1	Returning_Visitor	False	False
1	0	2	64.000000	0.000000	0.100000	0.0	Feb	2	2.0	NaN	2	Returning_Visitor	False	False
2	0	1	0.000000	0.200000	0.200000	0.0	Feb	4	1.0	NaN	3	Returning_Visitor	False	False
3	0	2	2.666667	0.050000	0.140000	0.0	Feb	3	2.0	2.0	4	Returning_Visitor	False	False
4	0	10	627.500000	0.020000	0.050000	0.0	Feb	3	3.0	1.0	4	Returning_Visitor	True	False
5	0	19	154.216667	0.015789	0.024561	0.0	Feb	2	2.0	1.0	3	Returning_Visitor	False	False
6	0	1	0.000000	0.200000	0.200000	0.4	Feb	2	4.0	3.0	3	Returning_Visitor	False	False
7	1	0	0.000000	0.200000	0.200000	0.0	Feb	1	2.0	1.0	5	Returning_Visitor	True	False
8	0	2	37.000000	0.000000	0.100000	0.8	Feb	2	2.0	2.0	3	Returning_Visitor	False	False
9	0	3	738.000000	0.000000	0.022222	0.4	Feb	2	4.0	1.0	2	Returning_Visitor	False	False

	Administrative	Administrative_Duration	Informational	ProductRelated	ProductRelated_Duration	BounceRates	ExitRates	PageValues	Month	OperatingSystems	Browser	Region	TrafficType	VisitorType	Weekend	Revenue
12320	0	0.00	0	8	143.583333	0.014286	0.050000	0.000000	Nov	2	2.0	3.0	1	Returning_Visitor	False	False
12321	0	0.00	0	6	0.000000	0.200000	0.200000	0.000000	Nov	1	8.0	4.0	1	Returning_Visitor	False	False
12322	6	76.25	0	22	1075.250000	0.000000	0.004167	0.000000	Dec	2	2.0	4.0	2	Returning_Visitor	False	False
12323	2	64.75	0	44	1157.976190	0.000000	0.013953	0.000000	Nov	2	2.0	1.0	10	Returning_Visitor	False	False
12324	0	0.00	1	16	503.000000	0.000000	0.037647	0.000000	Nov	2	2.0	1.0	1	Returning_Visitor	False	False
12325	3	145.00	0	53	1783.791667	0.007143	0.029031	12.241717	Dec	4	6.0	NaN	1	Returning_Visitor	True	False
12326	0	0.00	0	5	465.750000	0.000000	0.021333	0.000000	Nov	3	2.0	1.0	8	Returning_Visitor	True	False
12327	0	0.00	0	6	184.250000	0.083333	0.086667	0.000000	Nov	3	2.0	1.0	13	Returning_Visitor	True	False
12328	4	75.00	0	15	346.000000	0.000000	0.021053	0.000000	Nov	2	2.0	3.0	11	Returning_Visitor	False	False
12329	0	0.00	0	3	21.250000	0.000000	0.066667	0.000000	Nov	3	2.0	1.0	2	New_Visitor	True	False

Most frequently occurring

	ProductRelated	BounceRates	ExitRates	Month	OperatingSystems	Browser	Region	TrafficType	VisitorType	Weekend	Revenue	# duplicates
23	1	0.2	0.2	Mar	2	2.0	1.0	1	Returning_Visitor	False	False	12
38	1	0.2	0.2	May	2	2.0	1.0	3	Returning_Visitor	False	False	7
12	1	0.2	0.2	Dec	8	13.0	9.0	20	Other	False	False	5
33	1	0.2	0.2	May	1	1.0	1.0	3	Returning_Visitor	False	False	5
31	1	0.2	0.2	Mar	3	2.0	3.0	1	Returning_Visitor	False	False	4
0	1	0.2	0.2	Dec	1	1.0	1.0	1	Returning_Visitor	True	False	3
3	1	0.2	0.2	Dec	1	1.0	4.0	1	Returning_Visitor	True	False	3
5	1	0.2	0.2	Dec	2	2.0	1.0	1	Returning_Visitor	False	False	3
21	1	0.2	0.2	Mar	1	1.0	3.0	3	Returning_Visitor	False	False	3
22	1	0.2	0.2	Mar	1	1.0	8.0	1	Returning_Visitor	False	False	3

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring